<?
	global $db, $FullUrl,$hotellist,$provinceList;
	// select cac tinh co khach san
	$sql = "select province from hotels";
	$hotellist = $db -> getAll($sql);
	$strwhere = "";
	for ($ai=0;$ai<count($hotellist);$ai++) {
		$strwhere.= ($strwhere == '')?( ' id = ' . $hotellist[$ai]["province"] ): ' or id = ' . $hotellist[$ai]["province"];
	}
	$sql = "select * from provinces where " . $strwhere;
	
	$provinceList = $db -> getAll($sql);
	//echo " test = ". $provinceList[0]['name_vn'];
	include(UC_DIR.'Search.ctp');
?>